package com.trkj.dao.jpa;
import java.util.List;

import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.CrudRepository;
import com.trkj.pojos.DepositTable;

public interface IDepositTableDao extends CrudRepository<DepositTable, String> {

	public List<DepositTable> findByLiveid5(String liveID);
	
	/**
	 * 模糊查询当日押金号
	 * @param LikeID
	 * @return
	 */
	@Query("select D.depositid2 from DepositTable D "
			+ "where D.depositid2 like ?1")
	public List<String> queryDepositID(String LikeID);
	
	@Query("select D.depositstatus from DepositTable D "
			+ "where D.liveid5=?1")
	public String queryDepositIDStatus(String LikeID);

	
	

}
